﻿CREATE TABLE [dbo].[SlowestPages] (
    [WebApplicationID]       UNIQUEIDENTIFIER NOT NULL,
    [URL]                    NVARCHAR (300)   NOT NULL,
    [AverageDuration]        FLOAT (53)       NULL,
    [MinimumDuration]        FLOAT (53)       NULL,
    [MaximumDuraion]         FLOAT (53)       NULL,
    [AverageDatabaseQueries] INT              NULL,
    [MinimumDatabaseQueries] INT              NULL,
    [MaximumDatabseQueries]  INT              NULL,
    [NumberRequests]         INT              NULL,
    CONSTRAINT [PK_SlowestPages] PRIMARY KEY CLUSTERED ([URL] ASC),
    CONSTRAINT [FK_SlowestPages_WebApplication1] FOREIGN KEY ([WebApplicationID]) REFERENCES [dbo].[WebApplication] ([WebApplicationID])
);

